Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 200000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 257.5 MiB |
| Average record size in memory | 1.3 KiB |
Variable types
| Text | 6 |
|---|---|
| Categorical | 13 |
| Numeric | 3 |
| DateTime | 2 |
Is_Fraud is highly overall correlated with Transaction_Amount and 1 other fields | High correlation |
Transaction_Amount is highly overall correlated with Is_Fraud | High correlation |
Transaction_Location is highly overall correlated with Is_Fraud | High correlation |
Is_Fraud is highly imbalanced (63.4%) | Imbalance |
Customer_ID has unique values | Unique |
Customer_Name has unique values | Unique |
Transaction_ID has unique values | Unique |
Transaction_Date has unique values | Unique |
Reproduction
| Analysis started | 2025-02-27 02:21:27.953744 |
|---|---|
| Analysis finished | 2025-02-27 02:22:17.490265 |
| Duration | 49.54 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Customer_ID
Text
Unique 
| Distinct | 200000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 200000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | CUST000001 |
|---|---|
| 2nd row | CUST000002 |
| 3rd row | CUST000003 |
| 4th row | CUST000004 |
| 5th row | CUST000005 |
| Value | Count | Frequency (%) |
| cust199985 | 1 | < 0.1% |
| cust199986 | 1 | < 0.1% |
| cust199987 | 1 | < 0.1% |
| cust199988 | 1 | < 0.1% |
| cust199989 | 1 | < 0.1% |
| cust199990 | 1 | < 0.1% |
| cust199991 | 1 | < 0.1% |
| cust199992 | 1 | < 0.1% |
| cust199993 | 1 | < 0.1% |
| cust199994 | 1 | < 0.1% |
| Other values (199990) | 199990 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 200000 | |
| U | 200000 | |
| S | 200000 | |
| T | 200000 | |
| 1 | 200000 | |
| 0 | 199999 | |
| 2 | 100001 | 5.0% |
| 9 | 100000 | 5.0% |
| 4 | 100000 | 5.0% |
| 8 | 100000 | 5.0% |
| Other values (4) | 400000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2000000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 200000 | |
| U | 200000 | |
| S | 200000 | |
| T | 200000 | |
| 1 | 200000 | |
| 0 | 199999 | |
| 2 | 100001 | 5.0% |
| 9 | 100000 | 5.0% |
| 4 | 100000 | 5.0% |
| 8 | 100000 | 5.0% |
| Other values (4) | 400000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2000000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 200000 | |
| U | 200000 | |
| S | 200000 | |
| T | 200000 | |
| 1 | 200000 | |
| 0 | 199999 | |
| 2 | 100001 | 5.0% |
| 9 | 100000 | 5.0% |
| 4 | 100000 | 5.0% |
| 8 | 100000 | 5.0% |
| Other values (4) | 400000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2000000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 200000 | |
| U | 200000 | |
| S | 200000 | |
| T | 200000 | |
| 1 | 200000 | |
| 0 | 199999 | |
| 2 | 100001 | 5.0% |
| 9 | 100000 | 5.0% |
| 4 | 100000 | 5.0% |
| 8 | 100000 | 5.0% |
| Other values (4) | 400000 |
Customer_Name
Text
Unique 
| Distinct | 200000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 14.444475 |
| Min length | 10 |
Unique
| Unique | 200000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Customer_1 |
|---|---|
| 2nd row | Customer_2 |
| 3rd row | Customer_3 |
| 4th row | Customer_4 |
| 5th row | Customer_5 |
| Value | Count | Frequency (%) |
| customer_199985 | 1 | < 0.1% |
| customer_199986 | 1 | < 0.1% |
| customer_199987 | 1 | < 0.1% |
| customer_199988 | 1 | < 0.1% |
| customer_199989 | 1 | < 0.1% |
| customer_199990 | 1 | < 0.1% |
| customer_199991 | 1 | < 0.1% |
| customer_199992 | 1 | < 0.1% |
| customer_199993 | 1 | < 0.1% |
| customer_199994 | 1 | < 0.1% |
| Other values (199990) | 199990 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 200000 | 6.9% |
| u | 200000 | 6.9% |
| s | 200000 | 6.9% |
| t | 200000 | 6.9% |
| o | 200000 | 6.9% |
| m | 200000 | 6.9% |
| e | 200000 | 6.9% |
| r | 200000 | 6.9% |
| _ | 200000 | 6.9% |
| 1 | 200000 | 6.9% |
| Other values (9) | 888895 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2888895 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 200000 | 6.9% |
| u | 200000 | 6.9% |
| s | 200000 | 6.9% |
| t | 200000 | 6.9% |
| o | 200000 | 6.9% |
| m | 200000 | 6.9% |
| e | 200000 | 6.9% |
| r | 200000 | 6.9% |
| _ | 200000 | 6.9% |
| 1 | 200000 | 6.9% |
| Other values (9) | 888895 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2888895 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 200000 | 6.9% |
| u | 200000 | 6.9% |
| s | 200000 | 6.9% |
| t | 200000 | 6.9% |
| o | 200000 | 6.9% |
| m | 200000 | 6.9% |
| e | 200000 | 6.9% |
| r | 200000 | 6.9% |
| _ | 200000 | 6.9% |
| 1 | 200000 | 6.9% |
| Other values (9) | 888895 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2888895 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 200000 | 6.9% |
| u | 200000 | 6.9% |
| s | 200000 | 6.9% |
| t | 200000 | 6.9% |
| o | 200000 | 6.9% |
| m | 200000 | 6.9% |
| e | 200000 | 6.9% |
| r | 200000 | 6.9% |
| _ | 200000 | 6.9% |
| 1 | 200000 | 6.9% |
| Other values (9) | 888895 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.00232 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Male |
|---|---|
| 2nd row | Female |
| 3rd row | Female |
| 4th row | Female |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Female | 100232 | |
| Male | 99768 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| female | 100232 | |
| male | 99768 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 300232 | |
| a | 200000 | |
| l | 200000 | |
| F | 100232 | 10.0% |
| m | 100232 | 10.0% |
| M | 99768 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1000464 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 300232 | |
| a | 200000 | |
| l | 200000 | |
| F | 100232 | 10.0% |
| m | 100232 | 10.0% |
| M | 99768 | 10.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1000464 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 300232 | |
| a | 200000 | |
| l | 200000 | |
| F | 100232 | 10.0% |
| m | 100232 | 10.0% |
| M | 99768 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1000464 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 300232 | |
| a | 200000 | |
| l | 200000 | |
| F | 100232 | 10.0% |
| m | 100232 | 10.0% |
| M | 99768 | 10.0% |
Age
Real number (ℝ)
| Distinct | 62 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.46971 |
| Minimum | 18 |
|---|---|
| Maximum | 79 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 33 |
| median | 48 |
| Q3 | 64 |
| 95-th percentile | 76 |
| Maximum | 79 |
| Range | 61 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 17.896964 |
|---|---|
| Coefficient of variation (CV) | 0.36924017 |
| Kurtosis | -1.1997223 |
| Mean | 48.46971 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 0.0007206454 |
| Sum | 9693942 |
| Variance | 320.30132 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 57 | 3343 | 1.7% |
| 40 | 3341 | 1.7% |
| 34 | 3316 | 1.7% |
| 22 | 3314 | 1.7% |
| 62 | 3313 | 1.7% |
| 49 | 3293 | 1.6% |
| 25 | 3286 | 1.6% |
| 44 | 3282 | 1.6% |
| 73 | 3279 | 1.6% |
| 70 | 3273 | 1.6% |
| Other values (52) | 166960 |
| Value | Count | Frequency (%) |
| 18 | 3261 | |
| 19 | 3265 | |
| 20 | 3264 | |
| 21 | 3184 | |
| 22 | 3314 | |
| 23 | 3257 | |
| 24 | 3162 | |
| 25 | 3286 | |
| 26 | 3202 | |
| 27 | 3188 |
| Value | Count | Frequency (%) |
| 79 | 3213 | |
| 78 | 3216 | |
| 77 | 3173 | |
| 76 | 3264 | |
| 75 | 3239 | |
| 74 | 3112 | |
| 73 | 3279 | |
| 72 | 3213 | |
| 71 | 3195 | |
| 70 | 3273 |
State
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.3 MiB |
| FL | |
|---|---|
| OH | |
| NY | |
| TX | |
| CA | |
| Other values (2) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CA |
|---|---|
| 2nd row | FL |
| 3rd row | PA |
| 4th row | NY |
| 5th row | OH |
Common Values
| Value | Count | Frequency (%) |
| FL | 28648 | |
| OH | 28631 | |
| NY | 28613 | |
| TX | 28549 | |
| CA | 28538 | |
| IL | 28525 | |
| PA | 28496 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| fl | 28648 | |
| oh | 28631 | |
| ny | 28613 | |
| tx | 28549 | |
| ca | 28538 | |
| il | 28525 | |
| pa | 28496 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 57173 | |
| A | 57034 | |
| F | 28648 | |
| O | 28631 | |
| H | 28631 | |
| N | 28613 | |
| Y | 28613 | |
| T | 28549 | |
| X | 28549 | |
| C | 28538 | |
| Other values (2) | 57021 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 400000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 57173 | |
| A | 57034 | |
| F | 28648 | |
| O | 28631 | |
| H | 28631 | |
| N | 28613 | |
| Y | 28613 | |
| T | 28549 | |
| X | 28549 | |
| C | 28538 | |
| Other values (2) | 57021 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 400000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 57173 | |
| A | 57034 | |
| F | 28648 | |
| O | 28631 | |
| H | 28631 | |
| N | 28613 | |
| Y | 28613 | |
| T | 28549 | |
| X | 28549 | |
| C | 28538 | |
| Other values (2) | 57021 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 400000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 57173 | |
| A | 57034 | |
| F | 28648 | |
| O | 28631 | |
| H | 28631 | |
| N | 28613 | |
| Y | 28613 | |
| T | 28549 | |
| X | 28549 | |
| C | 28538 | |
| Other values (2) | 57021 |
City
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.4 MiB |
| Chicago | |
|---|---|
| Houston | |
| Philadelphia | |
| Dallas | |
| Los Angeles | |
| Other values (2) |
Length
| Max length | 12 |
|---|---|
| Median length | 8 |
| Mean length | 7.999245 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Los Angeles |
|---|---|
| 2nd row | New York |
| 3rd row | Dallas |
| 4th row | Chicago |
| 5th row | Philadelphia |
Common Values
| Value | Count | Frequency (%) |
| Chicago | 28762 | |
| Houston | 28640 | |
| Philadelphia | 28583 | |
| Dallas | 28578 | |
| Los Angeles | 28507 | |
| Miami | 28482 | |
| New York | 28448 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| chicago | 28762 | |
| houston | 28640 | |
| philadelphia | 28583 | |
| dallas | 28578 | |
| los | 28507 | |
| angeles | 28507 | |
| miami | 28482 | |
| new | 28448 | |
| york | 28448 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 171566 | 10.7% |
| o | 142997 | 8.9% |
| i | 142892 | 8.9% |
| l | 142829 | 8.9% |
| s | 114232 | 7.1% |
| e | 114045 | 7.1% |
| h | 85928 | 5.4% |
| g | 57269 | 3.6% |
| n | 57147 | 3.6% |
| 56955 | 3.6% | |
| Other values (18) | 513989 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1599849 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 171566 | 10.7% |
| o | 142997 | 8.9% |
| i | 142892 | 8.9% |
| l | 142829 | 8.9% |
| s | 114232 | 7.1% |
| e | 114045 | 7.1% |
| h | 85928 | 5.4% |
| g | 57269 | 3.6% |
| n | 57147 | 3.6% |
| 56955 | 3.6% | |
| Other values (18) | 513989 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1599849 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 171566 | 10.7% |
| o | 142997 | 8.9% |
| i | 142892 | 8.9% |
| l | 142829 | 8.9% |
| s | 114232 | 7.1% |
| e | 114045 | 7.1% |
| h | 85928 | 5.4% |
| g | 57269 | 3.6% |
| n | 57147 | 3.6% |
| 56955 | 3.6% | |
| Other values (18) | 513989 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1599849 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 171566 | 10.7% |
| o | 142997 | 8.9% |
| i | 142892 | 8.9% |
| l | 142829 | 8.9% |
| s | 114232 | 7.1% |
| e | 114045 | 7.1% |
| h | 85928 | 5.4% |
| g | 57269 | 3.6% |
| n | 57147 | 3.6% |
| 56955 | 3.6% | |
| Other values (18) | 513989 |
Bank_Branch
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.4 MiB |
| Branch A | |
|---|---|
| Branch C | |
| Branch D | |
| Branch B |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Branch B |
|---|---|
| 2nd row | Branch C |
| 3rd row | Branch A |
| 4th row | Branch A |
| 5th row | Branch B |
Common Values
| Value | Count | Frequency (%) |
| Branch A | 50274 | |
| Branch C | 50027 | |
| Branch D | 49850 | |
| Branch B | 49849 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| branch | 200000 | |
| a | 50274 | 12.6% |
| c | 50027 | 12.5% |
| d | 49850 | 12.5% |
| b | 49849 | 12.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 249849 | |
| r | 200000 | |
| a | 200000 | |
| n | 200000 | |
| c | 200000 | |
| h | 200000 | |
| 200000 | ||
| A | 50274 | 3.1% |
| C | 50027 | 3.1% |
| D | 49850 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1600000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 249849 | |
| r | 200000 | |
| a | 200000 | |
| n | 200000 | |
| c | 200000 | |
| h | 200000 | |
| 200000 | ||
| A | 50274 | 3.1% |
| C | 50027 | 3.1% |
| D | 49850 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1600000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 249849 | |
| r | 200000 | |
| a | 200000 | |
| n | 200000 | |
| c | 200000 | |
| h | 200000 | |
| 200000 | ||
| A | 50274 | 3.1% |
| C | 50027 | 3.1% |
| D | 49850 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1600000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 249849 | |
| r | 200000 | |
| a | 200000 | |
| n | 200000 | |
| c | 200000 | |
| h | 200000 | |
| 200000 | ||
| A | 50274 | 3.1% |
| C | 50027 | 3.1% |
| D | 49850 | 3.1% |
Account_Type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.3 MiB |
| Savings | |
|---|---|
| Checking | |
| Business |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.401185 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Checking |
|---|---|
| 2nd row | Savings |
| 3rd row | Savings |
| 4th row | Savings |
| 5th row | Savings |
Common Values
| Value | Count | Frequency (%) |
| Savings | 119763 | |
| Checking | 60167 | |
| Business | 20070 | 10.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| savings | 119763 | |
| checking | 60167 | |
| business | 20070 | 10.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 200000 | |
| i | 200000 | |
| s | 179973 | |
| g | 179930 | |
| a | 119763 | |
| S | 119763 | |
| v | 119763 | |
| e | 80237 | |
| C | 60167 | 4.1% |
| h | 60167 | 4.1% |
| Other values (4) | 160474 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1480237 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 200000 | |
| i | 200000 | |
| s | 179973 | |
| g | 179930 | |
| a | 119763 | |
| S | 119763 | |
| v | 119763 | |
| e | 80237 | |
| C | 60167 | 4.1% |
| h | 60167 | 4.1% |
| Other values (4) | 160474 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1480237 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 200000 | |
| i | 200000 | |
| s | 179973 | |
| g | 179930 | |
| a | 119763 | |
| S | 119763 | |
| v | 119763 | |
| e | 80237 | |
| C | 60167 | 4.1% |
| h | 60167 | 4.1% |
| Other values (4) | 160474 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1480237 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 200000 | |
| i | 200000 | |
| s | 179973 | |
| g | 179930 | |
| a | 119763 | |
| S | 119763 | |
| v | 119763 | |
| e | 80237 | |
| C | 60167 | 4.1% |
| h | 60167 | 4.1% |
| Other values (4) | 160474 |
Transaction_ID
Text
Unique 
| Distinct | 200000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.2 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 200000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | TXN000000001 |
|---|---|
| 2nd row | TXN000000002 |
| 3rd row | TXN000000003 |
| 4th row | TXN000000004 |
| 5th row | TXN000000005 |
| Value | Count | Frequency (%) |
| txn000199985 | 1 | < 0.1% |
| txn000199986 | 1 | < 0.1% |
| txn000199987 | 1 | < 0.1% |
| txn000199988 | 1 | < 0.1% |
| txn000199989 | 1 | < 0.1% |
| txn000199990 | 1 | < 0.1% |
| txn000199991 | 1 | < 0.1% |
| txn000199992 | 1 | < 0.1% |
| txn000199993 | 1 | < 0.1% |
| txn000199994 | 1 | < 0.1% |
| Other values (199990) | 199990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 799999 | |
| T | 200000 | 8.3% |
| X | 200000 | 8.3% |
| N | 200000 | 8.3% |
| 1 | 200000 | 8.3% |
| 2 | 100001 | 4.2% |
| 9 | 100000 | 4.2% |
| 4 | 100000 | 4.2% |
| 8 | 100000 | 4.2% |
| 3 | 100000 | 4.2% |
| Other values (3) | 300000 | 12.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2400000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 799999 | |
| T | 200000 | 8.3% |
| X | 200000 | 8.3% |
| N | 200000 | 8.3% |
| 1 | 200000 | 8.3% |
| 2 | 100001 | 4.2% |
| 9 | 100000 | 4.2% |
| 4 | 100000 | 4.2% |
| 8 | 100000 | 4.2% |
| 3 | 100000 | 4.2% |
| Other values (3) | 300000 | 12.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2400000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 799999 | |
| T | 200000 | 8.3% |
| X | 200000 | 8.3% |
| N | 200000 | 8.3% |
| 1 | 200000 | 8.3% |
| 2 | 100001 | 4.2% |
| 9 | 100000 | 4.2% |
| 4 | 100000 | 4.2% |
| 8 | 100000 | 4.2% |
| 3 | 100000 | 4.2% |
| Other values (3) | 300000 | 12.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2400000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 799999 | |
| T | 200000 | 8.3% |
| X | 200000 | 8.3% |
| N | 200000 | 8.3% |
| 1 | 200000 | 8.3% |
| 2 | 100001 | 4.2% |
| 9 | 100000 | 4.2% |
| 4 | 100000 | 4.2% |
| 8 | 100000 | 4.2% |
| 3 | 100000 | 4.2% |
| Other values (3) | 300000 | 12.5% |
Transaction_Date
Date
Unique 
| Distinct | 200000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2023-01-01 00:00:00 |
|---|---|
| Maximum | 2023-05-19 21:19:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Transaction_Time
Date
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2025-02-26 00:00:00 |
|---|---|
| Maximum | 2025-02-26 23:59:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Transaction_Amount
Real number (ℝ)
High correlation 
| Distinct | 185461 |
|---|---|
| Distinct (%) | 92.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 105.03262 |
| Minimum | 5 |
|---|---|
| Maximum | 1897.8694 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 31.508303 |
| median | 52.831014 |
| Q3 | 75.871259 |
| 95-th percentile | 630.38974 |
| Maximum | 1897.8694 |
| Range | 1892.8694 |
| Interquartile range (IQR) | 44.362956 |
Descriptive statistics
| Standard deviation | 210.89496 |
|---|---|
| Coefficient of variation (CV) | 2.0078996 |
| Kurtosis | 15.452889 |
| Mean | 105.03262 |
| Median Absolute Deviation (MAD) | 22.128433 |
| Skewness | 3.9231113 |
| Sum | 21006524 |
| Variance | 44476.685 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 12341 | 6.2% |
| 500 | 2200 | 1.1% |
| 83.03462405 | 1 | < 0.1% |
| 51.52127843 | 1 | < 0.1% |
| 74.89715577 | 1 | < 0.1% |
| 642.9258356 | 1 | < 0.1% |
| 998.7898949 | 1 | < 0.1% |
| 772.0799109 | 1 | < 0.1% |
| 974.7373898 | 1 | < 0.1% |
| 990.3640153 | 1 | < 0.1% |
| Other values (185451) | 185451 |
| Value | Count | Frequency (%) |
| 5 | 12341 | |
| 5.000461214 | 1 | < 0.1% |
| 5.000605258 | 1 | < 0.1% |
| 5.002293223 | 1 | < 0.1% |
| 5.006229507 | 1 | < 0.1% |
| 5.007303913 | 1 | < 0.1% |
| 5.008446896 | 1 | < 0.1% |
| 5.010560559 | 1 | < 0.1% |
| 5.010751688 | 1 | < 0.1% |
| 5.010990974 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1897.869419 | 1 | |
| 1834.433622 | 1 | |
| 1820.311895 | 1 | |
| 1809.659966 | 1 | |
| 1797.684375 | 1 | |
| 1787.498 | 1 | |
| 1779.59386 | 1 | |
| 1772.913102 | 1 | |
| 1764.350422 | 1 | |
| 1760.67967 | 1 |
Merchant_ID
Text
| Distinct | 999 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.9 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.89141 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MERCHANT839 |
|---|---|
| 2nd row | MERCHANT50 |
| 3rd row | MERCHANT453 |
| 4th row | MERCHANT231 |
| 5th row | MERCHANT664 |
| Value | Count | Frequency (%) |
| merchant229 | 270 | 0.1% |
| merchant496 | 247 | 0.1% |
| merchant146 | 247 | 0.1% |
| merchant302 | 239 | 0.1% |
| merchant716 | 237 | 0.1% |
| merchant225 | 235 | 0.1% |
| merchant350 | 234 | 0.1% |
| merchant597 | 234 | 0.1% |
| merchant675 | 234 | 0.1% |
| merchant490 | 233 | 0.1% |
| Other values (989) | 197590 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 200000 | |
| E | 200000 | |
| R | 200000 | |
| C | 200000 | |
| H | 200000 | |
| A | 200000 | |
| N | 200000 | |
| T | 200000 | |
| 2 | 60436 | 2.8% |
| 5 | 60320 | 2.8% |
| Other values (8) | 457526 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2178282 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 200000 | |
| E | 200000 | |
| R | 200000 | |
| C | 200000 | |
| H | 200000 | |
| A | 200000 | |
| N | 200000 | |
| T | 200000 | |
| 2 | 60436 | 2.8% |
| 5 | 60320 | 2.8% |
| Other values (8) | 457526 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2178282 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 200000 | |
| E | 200000 | |
| R | 200000 | |
| C | 200000 | |
| H | 200000 | |
| A | 200000 | |
| N | 200000 | |
| T | 200000 | |
| 2 | 60436 | 2.8% |
| 5 | 60320 | 2.8% |
| Other values (8) | 457526 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2178282 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 200000 | |
| E | 200000 | |
| R | 200000 | |
| C | 200000 | |
| H | 200000 | |
| A | 200000 | |
| N | 200000 | |
| T | 200000 | |
| 2 | 60436 | 2.8% |
| 5 | 60320 | 2.8% |
| Other values (8) | 457526 |
Transaction_Type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.1 MiB |
| Online | |
|---|---|
| POS | |
| ATM Withdrawal |
Length
| Max length | 14 |
|---|---|
| Median length | 6 |
| Mean length | 6.39575 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Online |
|---|---|
| 2nd row | ATM Withdrawal |
| 3rd row | ATM Withdrawal |
| 4th row | ATM Withdrawal |
| 5th row | Online |
Common Values
| Value | Count | Frequency (%) |
| Online | 80142 | |
| POS | 79974 | |
| ATM Withdrawal | 39884 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 80142 | |
| pos | 79974 | |
| atm | 39884 | |
| withdrawal | 39884 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 160284 | |
| O | 160116 | |
| l | 120026 | 9.4% |
| i | 120026 | 9.4% |
| e | 80142 | 6.3% |
| P | 79974 | 6.3% |
| S | 79974 | 6.3% |
| a | 79768 | 6.2% |
| T | 39884 | 3.1% |
| A | 39884 | 3.1% |
| Other values (8) | 319072 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1279150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 160284 | |
| O | 160116 | |
| l | 120026 | 9.4% |
| i | 120026 | 9.4% |
| e | 80142 | 6.3% |
| P | 79974 | 6.3% |
| S | 79974 | 6.3% |
| a | 79768 | 6.2% |
| T | 39884 | 3.1% |
| A | 39884 | 3.1% |
| Other values (8) | 319072 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1279150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 160284 | |
| O | 160116 | |
| l | 120026 | 9.4% |
| i | 120026 | 9.4% |
| e | 80142 | 6.3% |
| P | 79974 | 6.3% |
| S | 79974 | 6.3% |
| a | 79768 | 6.2% |
| T | 39884 | 3.1% |
| A | 39884 | 3.1% |
| Other values (8) | 319072 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1279150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 160284 | |
| O | 160116 | |
| l | 120026 | 9.4% |
| i | 120026 | 9.4% |
| e | 80142 | 6.3% |
| P | 79974 | 6.3% |
| S | 79974 | 6.3% |
| a | 79768 | 6.2% |
| T | 39884 | 3.1% |
| A | 39884 | 3.1% |
| Other values (8) | 319072 |
Merchant_Category
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.6 MiB |
| Travel | |
|---|---|
| Luxury | |
| Online Services | |
| Electronics | |
| Grocery |
Length
| Max length | 15 |
|---|---|
| Median length | 11 |
| Mean length | 8.841625 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Clothing |
|---|---|
| 2nd row | Luxury |
| 3rd row | Travel |
| 4th row | Clothing |
| 5th row | Electronics |
Common Values
| Value | Count | Frequency (%) |
| Travel | 35929 | |
| Luxury | 35605 | |
| Online Services | 35545 | |
| Electronics | 31180 | |
| Grocery | 30962 | |
| Clothing | 30779 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| travel | 35929 | |
| luxury | 35605 | |
| online | 35545 | |
| services | 35545 | |
| electronics | 31180 | |
| grocery | 30962 | |
| clothing | 30779 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 204706 | 11.6% |
| r | 200183 | 11.3% |
| l | 133433 | 7.5% |
| n | 133049 | 7.5% |
| i | 133049 | 7.5% |
| c | 128867 | 7.3% |
| o | 92921 | 5.3% |
| v | 71474 | 4.0% |
| u | 71210 | 4.0% |
| s | 66725 | 3.8% |
| Other values (14) | 532708 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1768325 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 204706 | 11.6% |
| r | 200183 | 11.3% |
| l | 133433 | 7.5% |
| n | 133049 | 7.5% |
| i | 133049 | 7.5% |
| c | 128867 | 7.3% |
| o | 92921 | 5.3% |
| v | 71474 | 4.0% |
| u | 71210 | 4.0% |
| s | 66725 | 3.8% |
| Other values (14) | 532708 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1768325 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 204706 | 11.6% |
| r | 200183 | 11.3% |
| l | 133433 | 7.5% |
| n | 133049 | 7.5% |
| i | 133049 | 7.5% |
| c | 128867 | 7.3% |
| o | 92921 | 5.3% |
| v | 71474 | 4.0% |
| u | 71210 | 4.0% |
| s | 66725 | 3.8% |
| Other values (14) | 532708 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1768325 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 204706 | 11.6% |
| r | 200183 | 11.3% |
| l | 133433 | 7.5% |
| n | 133049 | 7.5% |
| i | 133049 | 7.5% |
| c | 128867 | 7.3% |
| o | 92921 | 5.3% |
| v | 71474 | 4.0% |
| u | 71210 | 4.0% |
| s | 66725 | 3.8% |
| Other values (14) | 532708 |
Account_Balance
Real number (ℝ)
| Distinct | 198734 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4995.8658 |
| Minimum | 0 |
|---|---|
| Maximum | 13631.898 |
| Zeros | 1267 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1690.519 |
| Q1 | 3646.6209 |
| median | 4987.4005 |
| Q3 | 6343.9981 |
| 95-th percentile | 8296.04 |
| Maximum | 13631.898 |
| Range | 13631.898 |
| Interquartile range (IQR) | 2697.3772 |
Descriptive statistics
| Standard deviation | 1990.9146 |
|---|---|
| Coefficient of variation (CV) | 0.39851242 |
| Kurtosis | -0.11582181 |
| Mean | 4995.8658 |
| Median Absolute Deviation (MAD) | 1348.3527 |
| Skewness | 0.044220137 |
| Sum | 9.9917316 × 108 |
| Variance | 3963740.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1267 | 0.6% |
| 4070.596903 | 1 | < 0.1% |
| 4790.814115 | 1 | < 0.1% |
| 2799.823637 | 1 | < 0.1% |
| 3511.964463 | 1 | < 0.1% |
| 6325.143822 | 1 | < 0.1% |
| 4943.596395 | 1 | < 0.1% |
| 5517.654152 | 1 | < 0.1% |
| 6330.928087 | 1 | < 0.1% |
| 3392.716244 | 1 | < 0.1% |
| Other values (198724) | 198724 |
| Value | Count | Frequency (%) |
| 0 | 1267 | |
| 0.002169337859 | 1 | < 0.1% |
| 0.4378865496 | 1 | < 0.1% |
| 2.004019109 | 1 | < 0.1% |
| 3.956628034 | 1 | < 0.1% |
| 4.046878393 | 1 | < 0.1% |
| 5.956477747 | 1 | < 0.1% |
| 6.417498548 | 1 | < 0.1% |
| 6.990873221 | 1 | < 0.1% |
| 6.991436561 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13631.89815 | 1 | |
| 13324.62493 | 1 | |
| 13305.5696 | 1 | |
| 13030.04863 | 1 | |
| 12991.81541 | 1 | |
| 12908.76152 | 1 | |
| 12879.6356 | 1 | |
| 12766.36252 | 1 | |
| 12732.06282 | 1 | |
| 12624.48431 | 1 |
Transaction_Device
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.0 MiB |
| Web | |
|---|---|
| ATM | |
| POS Terminal | |
| Mobile |
Length
| Max length | 12 |
|---|---|
| Median length | 3 |
| Mean length | 5.78529 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | POS Terminal |
|---|---|
| 2nd row | Web |
| 3rd row | POS Terminal |
| 4th row | POS Terminal |
| 5th row | Web |
Common Values
| Value | Count | Frequency (%) |
| Web | 53687 | |
| ATM | 53499 | |
| POS Terminal | 46436 | |
| Mobile | 46378 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| web | 53687 | |
| atm | 53499 | |
| pos | 46436 | |
| terminal | 46436 | |
| mobile | 46378 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 146501 | |
| b | 100065 | 8.6% |
| T | 99935 | 8.6% |
| M | 99877 | 8.6% |
| l | 92814 | 8.0% |
| i | 92814 | 8.0% |
| W | 53687 | 4.6% |
| A | 53499 | 4.6% |
| P | 46436 | 4.0% |
| S | 46436 | 4.0% |
| Other values (7) | 324994 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1157058 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 146501 | |
| b | 100065 | 8.6% |
| T | 99935 | 8.6% |
| M | 99877 | 8.6% |
| l | 92814 | 8.0% |
| i | 92814 | 8.0% |
| W | 53687 | 4.6% |
| A | 53499 | 4.6% |
| P | 46436 | 4.0% |
| S | 46436 | 4.0% |
| Other values (7) | 324994 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1157058 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 146501 | |
| b | 100065 | 8.6% |
| T | 99935 | 8.6% |
| M | 99877 | 8.6% |
| l | 92814 | 8.0% |
| i | 92814 | 8.0% |
| W | 53687 | 4.6% |
| A | 53499 | 4.6% |
| P | 46436 | 4.0% |
| S | 46436 | 4.0% |
| Other values (7) | 324994 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1157058 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 146501 | |
| b | 100065 | 8.6% |
| T | 99935 | 8.6% |
| M | 99877 | 8.6% |
| l | 92814 | 8.0% |
| i | 92814 | 8.0% |
| W | 53687 | 4.6% |
| A | 53499 | 4.6% |
| P | 46436 | 4.0% |
| S | 46436 | 4.0% |
| Other values (7) | 324994 |
Transaction_Location
Categorical
High correlation 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.3 MiB |
| OH | |
|---|---|
| PA | |
| IL | |
| CA | |
| TX | |
| Other values (5) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CA |
|---|---|
| 2nd row | TX |
| 3rd row | IL |
| 4th row | CA |
| 5th row | PA |
Common Values
| Value | Count | Frequency (%) |
| OH | 26773 | |
| PA | 26689 | |
| IL | 26645 | |
| CA | 26556 | |
| TX | 26489 | |
| FL | 26434 | |
| NY | 26414 | |
| Hi | 4721 | 2.4% |
| Un | 4641 | 2.3% |
| Of | 4638 | 2.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| oh | 26773 | |
| pa | 26689 | |
| il | 26645 | |
| ca | 26556 | |
| tx | 26489 | |
| fl | 26434 | |
| ny | 26414 | |
| hi | 4721 | 2.4% |
| un | 4641 | 2.3% |
| of | 4638 | 2.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 53245 | |
| L | 53079 | |
| H | 31494 | |
| O | 31411 | |
| P | 26689 | 6.7% |
| I | 26645 | 6.7% |
| C | 26556 | 6.6% |
| T | 26489 | 6.6% |
| X | 26489 | 6.6% |
| F | 26434 | 6.6% |
| Other values (6) | 71469 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 400000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 53245 | |
| L | 53079 | |
| H | 31494 | |
| O | 31411 | |
| P | 26689 | 6.7% |
| I | 26645 | 6.7% |
| C | 26556 | 6.6% |
| T | 26489 | 6.6% |
| X | 26489 | 6.6% |
| F | 26434 | 6.6% |
| Other values (6) | 71469 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 400000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 53245 | |
| L | 53079 | |
| H | 31494 | |
| O | 31411 | |
| P | 26689 | 6.7% |
| I | 26645 | 6.7% |
| C | 26556 | 6.6% |
| T | 26489 | 6.6% |
| X | 26489 | 6.6% |
| F | 26434 | 6.6% |
| Other values (6) | 71469 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 400000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 53245 | |
| L | 53079 | |
| H | 31494 | |
| O | 31411 | |
| P | 26689 | 6.7% |
| I | 26645 | 6.7% |
| C | 26556 | 6.6% |
| T | 26489 | 6.6% |
| X | 26489 | 6.6% |
| F | 26434 | 6.6% |
| Other values (6) | 71469 |
Device_Type
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.3 MiB |
| Windows PC | |
|---|---|
| ATM Machine | |
| Mac | |
| Android | |
| Linux |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 7.24327 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Windows PC |
|---|---|
| 2nd row | Android |
| 3rd row | Windows PC |
| 4th row | Windows PC |
| 5th row | Linux |
Common Values
| Value | Count | Frequency (%) |
| Windows PC | 38104 | |
| ATM Machine | 37942 | |
| Mac | 31173 | |
| Android | 31016 | |
| Linux | 30969 | |
| iPhone | 30796 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| windows | 38104 | |
| pc | 38104 | |
| atm | 37942 | |
| machine | 37942 | |
| mac | 31173 | |
| android | 31016 | |
| linux | 30969 | |
| iphone | 30796 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 168827 | 11.7% |
| n | 168827 | 11.7% |
| M | 107057 | 7.4% |
| d | 100136 | 6.9% |
| o | 99916 | 6.9% |
| 76046 | 5.2% | |
| c | 69115 | 4.8% |
| a | 69115 | 4.8% |
| A | 68958 | 4.8% |
| P | 68900 | 4.8% |
| Other values (11) | 451757 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1448654 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 168827 | 11.7% |
| n | 168827 | 11.7% |
| M | 107057 | 7.4% |
| d | 100136 | 6.9% |
| o | 99916 | 6.9% |
| 76046 | 5.2% | |
| c | 69115 | 4.8% |
| a | 69115 | 4.8% |
| A | 68958 | 4.8% |
| P | 68900 | 4.8% |
| Other values (11) | 451757 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1448654 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 168827 | 11.7% |
| n | 168827 | 11.7% |
| M | 107057 | 7.4% |
| d | 100136 | 6.9% |
| o | 99916 | 6.9% |
| 76046 | 5.2% | |
| c | 69115 | 4.8% |
| a | 69115 | 4.8% |
| A | 68958 | 4.8% |
| P | 68900 | 4.8% |
| Other values (11) | 451757 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1448654 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 168827 | 11.7% |
| n | 168827 | 11.7% |
| M | 107057 | 7.4% |
| d | 100136 | 6.9% |
| o | 99916 | 6.9% |
| 76046 | 5.2% | |
| c | 69115 | 4.8% |
| a | 69115 | 4.8% |
| A | 68958 | 4.8% |
| P | 68900 | 4.8% |
| Other values (11) | 451757 |
Is_Fraud
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 MiB |
| 0 | |
|---|---|
| 1 | 14000 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 186000 | |
| 1 | 14000 | 7.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 186000 | |
| 1 | 14000 | 7.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 186000 | |
| 1 | 14000 | 7.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 200000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 186000 | |
| 1 | 14000 | 7.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 200000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 186000 | |
| 1 | 14000 | 7.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 200000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 186000 | |
| 1 | 14000 | 7.0% |
Transaction_Currency
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.4 MiB |
| USD | |
|---|---|
| CAD | |
| GBP | 10009 |
| EUR | 9931 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | EUR |
| 4th row | CAD |
| 5th row | CAD |
Common Values
| Value | Count | Frequency (%) |
| USD | 160082 | |
| CAD | 19978 | 10.0% |
| GBP | 10009 | 5.0% |
| EUR | 9931 | 5.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 160082 | |
| cad | 19978 | 10.0% |
| gbp | 10009 | 5.0% |
| eur | 9931 | 5.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 180060 | |
| U | 170013 | |
| S | 160082 | |
| C | 19978 | 3.3% |
| A | 19978 | 3.3% |
| G | 10009 | 1.7% |
| B | 10009 | 1.7% |
| P | 10009 | 1.7% |
| E | 9931 | 1.7% |
| R | 9931 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 600000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| D | 180060 | |
| U | 170013 | |
| S | 160082 | |
| C | 19978 | 3.3% |
| A | 19978 | 3.3% |
| G | 10009 | 1.7% |
| B | 10009 | 1.7% |
| P | 10009 | 1.7% |
| E | 9931 | 1.7% |
| R | 9931 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 600000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| D | 180060 | |
| U | 170013 | |
| S | 160082 | |
| C | 19978 | 3.3% |
| A | 19978 | 3.3% |
| G | 10009 | 1.7% |
| B | 10009 | 1.7% |
| P | 10009 | 1.7% |
| E | 9931 | 1.7% |
| R | 9931 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 600000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| D | 180060 | |
| U | 170013 | |
| S | 160082 | |
| C | 19978 | 3.3% |
| A | 19978 | 3.3% |
| G | 10009 | 1.7% |
| B | 10009 | 1.7% |
| P | 10009 | 1.7% |
| E | 9931 | 1.7% |
| R | 9931 | 1.7% |
Customer_Contact
Text
| Distinct | 197504 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.0 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 195021 ? |
|---|---|
| Unique (%) | 97.5% |
Sample
| 1st row | +1-240-2997 |
|---|---|
| 2nd row | +1-641-1940 |
| 3rd row | +1-685-4317 |
| 4th row | +1-650-5207 |
| 5th row | +1-995-5816 |
| Value | Count | Frequency (%) |
| 1-349-4074 | 3 | < 0.1% |
| 1-622-6452 | 3 | < 0.1% |
| 1-973-1511 | 3 | < 0.1% |
| 1-593-3288 | 3 | < 0.1% |
| 1-245-1873 | 3 | < 0.1% |
| 1-959-4796 | 3 | < 0.1% |
| 1-560-9175 | 3 | < 0.1% |
| 1-438-3247 | 3 | < 0.1% |
| 1-112-1104 | 3 | < 0.1% |
| 1-911-8493 | 3 | < 0.1% |
| Other values (197494) | 199970 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 400000 | |
| 1 | 345174 | |
| + | 200000 | |
| 5 | 144627 | 6.6% |
| 7 | 144595 | 6.6% |
| 3 | 144571 | 6.6% |
| 2 | 144533 | 6.6% |
| 8 | 144338 | 6.6% |
| 6 | 144288 | 6.6% |
| 4 | 143979 | 6.5% |
| Other values (2) | 243895 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2200000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 400000 | |
| 1 | 345174 | |
| + | 200000 | |
| 5 | 144627 | 6.6% |
| 7 | 144595 | 6.6% |
| 3 | 144571 | 6.6% |
| 2 | 144533 | 6.6% |
| 8 | 144338 | 6.6% |
| 6 | 144288 | 6.6% |
| 4 | 143979 | 6.5% |
| Other values (2) | 243895 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2200000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 400000 | |
| 1 | 345174 | |
| + | 200000 | |
| 5 | 144627 | 6.6% |
| 7 | 144595 | 6.6% |
| 3 | 144571 | 6.6% |
| 2 | 144533 | 6.6% |
| 8 | 144338 | 6.6% |
| 6 | 144288 | 6.6% |
| 4 | 143979 | 6.5% |
| Other values (2) | 243895 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2200000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 400000 | |
| 1 | 345174 | |
| + | 200000 | |
| 5 | 144627 | 6.6% |
| 7 | 144595 | 6.6% |
| 3 | 144571 | 6.6% |
| 2 | 144533 | 6.6% |
| 8 | 144338 | 6.6% |
| 6 | 144288 | 6.6% |
| 4 | 143979 | 6.5% |
| Other values (2) | 243895 |
Transaction_Description
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.4 MiB |
| Refund | |
|---|---|
| Gift | |
| Bill Payment | |
| Subscription | |
| Payment |
Length
| Max length | 12 |
|---|---|
| Median length | 7 |
| Mean length | 8.197145 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Gift |
|---|---|
| 2nd row | Payment |
| 3rd row | Subscription |
| 4th row | Subscription |
| 5th row | Gift |
Common Values
| Value | Count | Frequency (%) |
| Refund | 40205 | |
| Gift | 40047 | |
| Bill Payment | 40039 | |
| Subscription | 39916 | |
| Payment | 39793 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 79832 | |
| refund | 40205 | |
| gift | 40047 | |
| bill | 40039 | |
| subscription | 39916 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 159953 | 9.8% |
| i | 159918 | 9.8% |
| t | 159795 | 9.7% |
| e | 120037 | 7.3% |
| f | 80252 | 4.9% |
| u | 80121 | 4.9% |
| l | 80078 | 4.9% |
| y | 79832 | 4.9% |
| a | 79832 | 4.9% |
| m | 79832 | 4.9% |
| Other values (13) | 559779 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1639429 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 159953 | 9.8% |
| i | 159918 | 9.8% |
| t | 159795 | 9.7% |
| e | 120037 | 7.3% |
| f | 80252 | 4.9% |
| u | 80121 | 4.9% |
| l | 80078 | 4.9% |
| y | 79832 | 4.9% |
| a | 79832 | 4.9% |
| m | 79832 | 4.9% |
| Other values (13) | 559779 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1639429 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 159953 | 9.8% |
| i | 159918 | 9.8% |
| t | 159795 | 9.7% |
| e | 120037 | 7.3% |
| f | 80252 | 4.9% |
| u | 80121 | 4.9% |
| l | 80078 | 4.9% |
| y | 79832 | 4.9% |
| a | 79832 | 4.9% |
| m | 79832 | 4.9% |
| Other values (13) | 559779 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1639429 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 159953 | 9.8% |
| i | 159918 | 9.8% |
| t | 159795 | 9.7% |
| e | 120037 | 7.3% |
| f | 80252 | 4.9% |
| u | 80121 | 4.9% |
| l | 80078 | 4.9% |
| y | 79832 | 4.9% |
| a | 79832 | 4.9% |
| m | 79832 | 4.9% |
| Other values (13) | 559779 |
Customer_Email
Text
| Distinct | 8999 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 14.9 MiB |
Length
| Max length | 21 |
|---|---|
| Median length | 21 |
| Mean length | 21 |
| Min length | 21 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | customer2148@bank.com |
|---|---|
| 2nd row | customer8393@bank.com |
| 3rd row | customer8594@bank.com |
| 4th row | customer1396@bank.com |
| 5th row | customer1126@bank.com |
| Value | Count | Frequency (%) |
| customer5223@bank.com | 44 | < 0.1% |
| customer6842@bank.com | 43 | < 0.1% |
| customer4526@bank.com | 43 | < 0.1% |
| customer7358@bank.com | 42 | < 0.1% |
| customer7532@bank.com | 41 | < 0.1% |
| customer6718@bank.com | 40 | < 0.1% |
| customer4530@bank.com | 40 | < 0.1% |
| customer1298@bank.com | 40 | < 0.1% |
| customer2562@bank.com | 39 | < 0.1% |
| customer3356@bank.com | 39 | < 0.1% |
| Other values (8989) | 199589 |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 400000 | 9.5% |
| o | 400000 | 9.5% |
| m | 400000 | 9.5% |
| u | 200000 | 4.8% |
| t | 200000 | 4.8% |
| s | 200000 | 4.8% |
| e | 200000 | 4.8% |
| r | 200000 | 4.8% |
| @ | 200000 | 4.8% |
| n | 200000 | 4.8% |
| Other values (14) | 1600000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4200000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| c | 400000 | 9.5% |
| o | 400000 | 9.5% |
| m | 400000 | 9.5% |
| u | 200000 | 4.8% |
| t | 200000 | 4.8% |
| s | 200000 | 4.8% |
| e | 200000 | 4.8% |
| r | 200000 | 4.8% |
| @ | 200000 | 4.8% |
| n | 200000 | 4.8% |
| Other values (14) | 1600000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4200000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| c | 400000 | 9.5% |
| o | 400000 | 9.5% |
| m | 400000 | 9.5% |
| u | 200000 | 4.8% |
| t | 200000 | 4.8% |
| s | 200000 | 4.8% |
| e | 200000 | 4.8% |
| r | 200000 | 4.8% |
| @ | 200000 | 4.8% |
| n | 200000 | 4.8% |
| Other values (14) | 1600000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4200000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| c | 400000 | 9.5% |
| o | 400000 | 9.5% |
| m | 400000 | 9.5% |
| u | 200000 | 4.8% |
| t | 200000 | 4.8% |
| s | 200000 | 4.8% |
| e | 200000 | 4.8% |
| r | 200000 | 4.8% |
| @ | 200000 | 4.8% |
| n | 200000 | 4.8% |
| Other values (14) | 1600000 |
Interactions
Correlations
| Account_Balance | Account_Type | Age | Bank_Branch | City | Device_Type | Gender | Is_Fraud | Merchant_Category | State | Transaction_Amount | Transaction_Currency | Transaction_Description | Transaction_Device | Transaction_Location | Transaction_Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Account_Balance | 1.000 | 0.000 | -0.000 | 0.003 | 0.002 | 0.001 | 0.003 | 0.004 | 0.001 | 0.002 | 0.001 | 0.003 | 0.003 | 0.000 | 0.002 | 0.000 |
| Account_Type | 0.000 | 1.000 | 0.004 | 0.003 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.002 | 0.002 | 0.000 | 0.000 | 0.002 |
| Age | -0.000 | 0.004 | 1.000 | 0.000 | 0.000 | 0.002 | 0.004 | 0.000 | 0.001 | 0.002 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.001 |
| Bank_Branch | 0.003 | 0.003 | 0.000 | 1.000 | 0.003 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.005 | 0.002 | 0.002 | 0.003 | 0.003 |
| City | 0.002 | 0.000 | 0.000 | 0.003 | 1.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.001 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 |
| Device_Type | 0.001 | 0.002 | 0.002 | 0.001 | 0.000 | 1.000 | 0.000 | 0.350 | 0.040 | 0.000 | 0.157 | 0.000 | 0.000 | 0.052 | 0.157 | 0.000 |
| Gender | 0.003 | 0.000 | 0.004 | 0.000 | 0.005 | 0.000 | 1.000 | 0.000 | 0.003 | 0.003 | 0.003 | 0.003 | 0.000 | 0.000 | 0.004 | 0.000 |
| Is_Fraud | 0.004 | 0.000 | 0.000 | 0.000 | 0.000 | 0.350 | 0.000 | 1.000 | 0.256 | 0.001 | 1.000 | 0.000 | 0.003 | 0.255 | 1.000 | 0.000 |
| Merchant_Category | 0.001 | 0.000 | 0.001 | 0.000 | 0.000 | 0.040 | 0.003 | 0.256 | 1.000 | 0.001 | 0.114 | 0.000 | 0.000 | 0.038 | 0.114 | 0.000 |
| State | 0.002 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.003 | 0.001 | 0.001 | 1.000 | 0.000 | 0.000 | 0.004 | 0.004 | 0.003 | 0.000 |
| Transaction_Amount | 0.001 | 0.003 | 0.000 | 0.000 | 0.001 | 0.157 | 0.003 | 1.000 | 0.114 | 0.000 | 1.000 | 0.000 | 0.000 | 0.147 | 0.354 | 0.000 |
| Transaction_Currency | 0.003 | 0.002 | 0.002 | 0.005 | 0.000 | 0.000 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.003 | 0.000 |
| Transaction_Description | 0.003 | 0.002 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.003 | 0.000 | 0.004 | 0.000 | 0.000 | 1.000 | 0.000 | 0.002 | 0.003 |
| Transaction_Device | 0.000 | 0.000 | 0.000 | 0.002 | 0.004 | 0.052 | 0.000 | 0.255 | 0.038 | 0.004 | 0.147 | 0.000 | 0.000 | 1.000 | 0.147 | 0.003 |
| Transaction_Location | 0.002 | 0.000 | 0.000 | 0.003 | 0.000 | 0.157 | 0.004 | 1.000 | 0.114 | 0.003 | 0.354 | 0.003 | 0.002 | 0.147 | 1.000 | 0.004 |
| Transaction_Type | 0.000 | 0.002 | 0.001 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.003 | 0.004 | 1.000 |
Missing values
Sample
| Customer_ID | Customer_Name | Gender | Age | State | City | Bank_Branch | Account_Type | Transaction_ID | Transaction_Date | Transaction_Time | Transaction_Amount | Merchant_ID | Transaction_Type | Merchant_Category | Account_Balance | Transaction_Device | Transaction_Location | Device_Type | Is_Fraud | Transaction_Currency | Customer_Contact | Transaction_Description | Customer_Email | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CUST000001 | Customer_1 | Male | 25 | CA | Los Angeles | Branch B | Checking | TXN000000001 | 2023-01-01 00:00:00 | 00:00:00 | 102.690676 | MERCHANT839 | Online | Clothing | 1760.420524 | POS Terminal | CA | Windows PC | 0 | USD | +1-240-2997 | Gift | customer2148@bank.com |
| 1 | CUST000002 | Customer_2 | Female | 58 | FL | New York | Branch C | Savings | TXN000000002 | 2023-01-01 00:01:00 | 00:01:00 | 83.034624 | MERCHANT50 | ATM Withdrawal | Luxury | 7833.088780 | Web | TX | Android | 0 | USD | +1-641-1940 | Payment | customer8393@bank.com |
| 2 | CUST000003 | Customer_3 | Female | 71 | PA | Dallas | Branch A | Savings | TXN000000003 | 2023-01-01 00:02:00 | 00:02:00 | 51.521278 | MERCHANT453 | ATM Withdrawal | Travel | 7239.890561 | POS Terminal | IL | Windows PC | 0 | EUR | +1-685-4317 | Subscription | customer8594@bank.com |
| 3 | CUST000004 | Customer_4 | Female | 27 | NY | Chicago | Branch A | Savings | TXN000000004 | 2023-01-01 00:03:00 | 00:03:00 | 74.897156 | MERCHANT231 | ATM Withdrawal | Clothing | 4269.744125 | POS Terminal | CA | Windows PC | 0 | CAD | +1-650-5207 | Subscription | customer1396@bank.com |
| 4 | CUST000005 | Customer_5 | Male | 28 | OH | Philadelphia | Branch B | Savings | TXN000000005 | 2023-01-01 00:04:00 | 00:04:00 | 5.000000 | MERCHANT664 | Online | Electronics | 4877.511195 | Web | PA | Linux | 0 | CAD | +1-995-5816 | Gift | customer1126@bank.com |
| 5 | CUST000006 | Customer_6 | Male | 35 | IL | Philadelphia | Branch B | Checking | TXN000000006 | 2023-01-01 00:05:00 | 00:05:00 | 64.265487 | MERCHANT571 | Online | Luxury | 6608.633036 | ATM | IL | Mac | 0 | USD | +1-427-5502 | Refund | customer4636@bank.com |
| 6 | CUST000007 | Customer_7 | Male | 49 | TX | Miami | Branch B | Savings | TXN000000007 | 2023-01-01 00:06:00 | 00:06:00 | 33.407848 | MERCHANT49 | ATM Withdrawal | Luxury | 4070.596903 | POS Terminal | IL | Windows PC | 0 | USD | +1-534-6600 | Subscription | customer8995@bank.com |
| 7 | CUST000008 | Customer_8 | Female | 33 | PA | Los Angeles | Branch D | Business | TXN000000008 | 2023-01-01 00:07:00 | 00:07:00 | 21.495652 | MERCHANT767 | Online | Travel | 4790.814115 | POS Terminal | OH | ATM Machine | 0 | USD | +1-676-2700 | Payment | customer2414@bank.com |
| 8 | CUST000009 | Customer_9 | Female | 74 | OH | Houston | Branch A | Savings | TXN000000009 | 2023-01-01 00:08:00 | 00:08:00 | 31.181209 | MERCHANT203 | ATM Withdrawal | Grocery | 2799.823637 | Web | CA | Linux | 0 | USD | +1-265-6726 | Bill Payment | customer6549@bank.com |
| 9 | CUST000010 | Customer_10 | Female | 37 | FL | Philadelphia | Branch D | Savings | TXN000000010 | 2023-01-01 00:09:00 | 00:09:00 | 21.235605 | MERCHANT550 | Online | Travel | 3511.964463 | POS Terminal | TX | iPhone | 0 | USD | +1-546-6429 | Subscription | customer4352@bank.com |
| Customer_ID | Customer_Name | Gender | Age | State | City | Bank_Branch | Account_Type | Transaction_ID | Transaction_Date | Transaction_Time | Transaction_Amount | Merchant_ID | Transaction_Type | Merchant_Category | Account_Balance | Transaction_Device | Transaction_Location | Device_Type | Is_Fraud | Transaction_Currency | Customer_Contact | Transaction_Description | Customer_Email | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 199990 | CUST199991 | Customer_199991 | Female | 31 | FL | Chicago | Branch D | Savings | TXN000199991 | 2023-05-19 21:10:00 | 21:10:00 | 713.527806 | MERCHANT724 | POS | Luxury | 5026.085810 | Web | Of | Windows PC | 1 | USD | +1-928-9568 | Subscription | customer6942@bank.com |
| 199991 | CUST199992 | Customer_199992 | Female | 75 | OH | Chicago | Branch C | Business | TXN000199992 | 2023-05-19 21:11:00 | 21:11:00 | 729.985845 | MERCHANT32 | POS | Luxury | 8269.853573 | Web | Of | Windows PC | 1 | USD | +1-911-4172 | Subscription | customer6191@bank.com |
| 199992 | CUST199993 | Customer_199993 | Male | 69 | IL | Dallas | Branch C | Savings | TXN000199993 | 2023-05-19 21:12:00 | 21:12:00 | 805.121697 | MERCHANT947 | POS | Online Services | 7300.610412 | Web | Hi | Windows PC | 1 | EUR | +1-244-4245 | Bill Payment | customer4778@bank.com |
| 199993 | CUST199994 | Customer_199994 | Male | 44 | TX | Dallas | Branch C | Savings | TXN000199994 | 2023-05-19 21:13:00 | 21:13:00 | 500.000000 | MERCHANT21 | POS | Travel | 5084.616462 | ATM | Of | ATM Machine | 1 | EUR | +1-766-3547 | Gift | customer1396@bank.com |
| 199994 | CUST199995 | Customer_199995 | Male | 26 | OH | Miami | Branch D | Business | TXN000199995 | 2023-05-19 21:14:00 | 21:14:00 | 802.320096 | MERCHANT436 | POS | Luxury | 5592.085149 | Web | Un | ATM Machine | 1 | CAD | +1-696-4653 | Payment | customer2891@bank.com |
| 199995 | CUST199996 | Customer_199996 | Female | 50 | NY | Miami | Branch D | Savings | TXN000199996 | 2023-05-19 21:15:00 | 21:15:00 | 527.962149 | MERCHANT32 | Online | Online Services | 4465.649560 | ATM | Hi | Windows PC | 1 | USD | +1-103-6246 | Payment | customer9284@bank.com |
| 199996 | CUST199997 | Customer_199997 | Female | 69 | PA | New York | Branch B | Savings | TXN000199997 | 2023-05-19 21:16:00 | 21:16:00 | 568.070220 | MERCHANT585 | ATM Withdrawal | Luxury | 2164.251235 | ATM | Hi | Windows PC | 1 | CAD | +1-456-3560 | Subscription | customer8558@bank.com |
| 199997 | CUST199998 | Customer_199998 | Male | 23 | FL | Dallas | Branch A | Business | TXN000199998 | 2023-05-19 21:17:00 | 21:17:00 | 1178.822244 | MERCHANT669 | POS | Luxury | 1739.432350 | Web | Hi | Windows PC | 1 | USD | +1-337-4670 | Refund | customer7015@bank.com |
| 199998 | CUST199999 | Customer_199999 | Female | 36 | FL | Philadelphia | Branch B | Checking | TXN000199999 | 2023-05-19 21:18:00 | 21:18:00 | 1008.643360 | MERCHANT677 | Online | Online Services | 4797.744120 | ATM | Hi | ATM Machine | 1 | USD | +1-537-8714 | Subscription | customer2544@bank.com |
| 199999 | CUST200000 | Customer_200000 | Male | 36 | PA | Dallas | Branch D | Savings | TXN000200000 | 2023-05-19 21:19:00 | 21:19:00 | 789.449699 | MERCHANT805 | POS | Online Services | 3521.334811 | Web | Of | Windows PC | 1 | USD | +1-970-5789 | Subscription | customer3550@bank.com |